Field Types

Field Type

Example Usage

STRING

A string of one or more ASCII characters between x20 – xFB.

Format: STRING

Example: The quick brown fox jumped over the lazy dogs back

TEXT

A string of one or more ASCII characters between x20 – xFC. The xFC character is used to show line breaks.

Example: Please do the following: ü 1)Open the gateü 2)Walk-inü 3)Close the gate.

NUMBER

A sequence of one or more numeric characters (0-9) which may contain one decimal point (.) followed by 1 or more decimal places. Negative numbers are preceded by a single minus sign (-).

Format: NUMERIC(2)

Example: 27000.00

Format: NUMERIC(4)

Example: -1.2341

INTEGER

A sequence of one or more numeric characters (0-9). Negative numbers are preceded by a single minus sign (-).

Format: INTEGER

Example: 2712

Format: INTEGER

Example: -32

DATE

A complete date with a four digit year

Format: dd mon yyyy

Example: 23 OCT 2015

DATETIME

A combination of the DATE and TIME field types separated by a space.

TIME

A time with hours, minutes and seconds displayed in military format

Example: 13:23:10

YESNO

A single character. (Y) indicates yes or true. (N) indicates no or false

Example: Y

CODE

A STRING of one or more ASCII characters that must be in the list of strings specified for the field. For example, and orders status might be represented as either (O)pen, (C)losed, or Cancelled (X)

Example: C

ID

A string of one or more ASCII characters that must match a value in an existing file. For example, a customer number must match a key in the CUSTOMER file.

Example: 115